
create external table jms_ods.tab_dict
(
  type_code   string  comment'类型code'
  ,item_code   string  comment '数据项code'
  ,item_value  string  comment '数据项值'
  ,sort        string  comment '排序'
  ,create_time string  comment '创建时间'
  ,update_time string  comment '开启时间'
)COMMENT '数据字典表'
PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/tab_dict'
TBLPROPERTIES (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);
